object DataModule1: TDataModule1
  OldCreateOrder = False
  Height = 646
  Width = 1025
  object MySQL_Connection: TSQLConnection
    ConnectionName = 'MYSQLCONNECTION'
    DriverName = 'MySQL'
    GetDriverFunc = 'getSQLDriverMYSQL'
    LibraryName = 'dbxmys.dll'
    LoginPrompt = False
    Params.Strings = (
      'drivername=MySQL'
      'hostname=localhost'
      'Database=rating'
      'user_name=root'
      'password=1'
      'blobsize=-1'
      'localecode=0000'
      'compressed=False'
      'encrypted=False'
      'connecttimeout=60')
    VendorLib = 'LIBMYSQL.dll'
    Connected = True
    Left = 56
    Top = 24
  end
  object SQLQuery: TSQLQuery
    MaxBlobSize = -1
    Params = <>
    SQL.Strings = (
      'SELECT * FROM prepods')
    SQLConnection = MySQL_Connection
    Left = 536
    Top = 344
  end
  object lesson_typesDataSource: TDataSource
    DataSet = lessonTypesClientDataSet
    Left = 784
    Top = 264
  end
  object lessonTypesProvider: TDataSetProvider
    DataSet = lesson_typesQuery
    Left = 784
    Top = 152
  end
  object lessonTypesClientDataSet: TClientDataSet
    Active = True
    Aggregates = <>
    FieldDefs = <
      item
        Name = 'id'
        Attributes = [faRequired]
        DataType = ftInteger
      end
      item
        Name = 'title'
        Attributes = [faRequired]
        DataType = ftString
        Size = 50
      end>
    IndexDefs = <>
    Params = <>
    ProviderName = 'lessonTypesProvider'
    StoreDefs = True
    Left = 784
    Top = 208
  end
  object prepodsDataSource: TDataSource
    DataSet = prepodsClientDataSet
    Left = 56
    Top = 264
  end
  object prepodsProvider: TDataSetProvider
    DataSet = prepodsQuery
    Left = 56
    Top = 152
  end
  object prepodsClientDataSet: TClientDataSet
    Active = True
    Aggregates = <>
    FieldDefs = <
      item
        Name = 'id'
        Attributes = [faRequired]
        DataType = ftInteger
      end
      item
        Name = 'fio'
        Attributes = [faRequired]
        DataType = ftString
        Size = 50
      end
      item
        Name = 'login'
        DataType = ftString
        Size = 20
      end
      item
        Name = 'password'
        DataType = ftString
        Size = 20
      end>
    IndexDefs = <>
    Params = <>
    ProviderName = 'prepodsProvider'
    StoreDefs = True
    AfterScroll = prepodsClientDataSetAfterScroll
    Left = 56
    Top = 208
  end
  object predmetsDataSource: TDataSource
    DataSet = predmetsClientDataSet
    Left = 184
    Top = 264
  end
  object predmetsProvider: TDataSetProvider
    DataSet = predmetsQuery
    Left = 184
    Top = 152
  end
  object predmetsClientDataSet: TClientDataSet
    Active = True
    Aggregates = <>
    FieldDefs = <
      item
        Name = 'title'
        Attributes = [faRequired]
        DataType = ftString
        Size = 70
      end
      item
        Name = 'term'
        Attributes = [faRequired]
        DataType = ftShortint
      end
      item
        Name = 'short_title'
        DataType = ftString
        Size = 10
      end
      item
        Name = 'fio'
        DataType = ftString
        Size = 50
      end>
    IndexDefs = <>
    Params = <>
    ProviderName = 'predmetsProvider'
    StoreDefs = True
    Left = 184
    Top = 208
  end
  object groupsDataSource: TDataSource
    DataSet = groupsClientDataSet
    Left = 304
    Top = 264
  end
  object groupsProvider: TDataSetProvider
    DataSet = groupsQuery
    Left = 304
    Top = 152
  end
  object groupsClientDataSet: TClientDataSet
    Active = True
    Aggregates = <>
    FieldDefs = <
      item
        Name = 'id'
        Attributes = [faRequired]
        DataType = ftInteger
      end
      item
        Name = 'group_number'
        Attributes = [faRequired]
        DataType = ftString
        Size = 10
      end
      item
        Name = 'id_specs'
        Attributes = [faRequired]
        DataType = ftInteger
      end
      item
        Name = 'course'
        Attributes = [faRequired]
        DataType = ftInteger
      end>
    IndexDefs = <>
    Params = <>
    ProviderName = 'groupsProvider'
    StoreDefs = True
    Left = 304
    Top = 208
  end
  object studentsDataSource: TDataSource
    DataSet = studentsClientDataSet
    Left = 920
    Top = 264
  end
  object studentsProvider: TDataSetProvider
    DataSet = studentsQuery
    Left = 920
    Top = 152
  end
  object studentsClientDataSet: TClientDataSet
    Active = True
    Aggregates = <>
    FieldDefs = <
      item
        Name = 'id'
        Attributes = [faRequired]
        DataType = ftInteger
      end
      item
        Name = 'fio'
        Attributes = [faRequired]
        DataType = ftString
        Size = 50
      end
      item
        Name = 'begin_year'
        Attributes = [faRequired]
        DataType = ftSmallint
      end
      item
        Name = 'end_year'
        Attributes = [faRequired]
        DataType = ftSmallint
      end
      item
        Name = 'id_group'
        Attributes = [faRequired]
        DataType = ftInteger
      end>
    IndexDefs = <>
    Params = <>
    ProviderName = 'studentsProvider'
    StoreDefs = True
    Left = 920
    Top = 208
  end
  object assistentsDataSource: TDataSource
    DataSet = assistentsClientDataSet
    Left = 528
    Top = 264
  end
  object assistentsProvider: TDataSetProvider
    DataSet = assistentsQuery
    Left = 528
    Top = 152
  end
  object assistentsClientDataSet: TClientDataSet
    Active = True
    Aggregates = <>
    FieldDefs = <
      item
        Name = 'id'
        Attributes = [faRequired]
        DataType = ftInteger
      end
      item
        Name = 'id_study_plan'
        Attributes = [faRequired]
        DataType = ftInteger
      end
      item
        Name = 'id_prepod'
        Attributes = [faRequired]
        DataType = ftInteger
      end
      item
        Name = 'id_group'
        Attributes = [faRequired]
        DataType = ftInteger
      end
      item
        Name = 'subgroup_number'
        DataType = ftInteger
      end>
    IndexDefs = <>
    Params = <>
    ProviderName = 'assistentsProvider'
    StoreDefs = True
    Left = 528
    Top = 208
  end
  object specsDataSource: TDataSource
    DataSet = specsClientDataSet
    Left = 416
    Top = 264
  end
  object specsProvider: TDataSetProvider
    DataSet = specsQuery
    Left = 416
    Top = 152
  end
  object specsClientDataSet: TClientDataSet
    Active = True
    Aggregates = <>
    FieldDefs = <
      item
        Name = 'id'
        Attributes = [faRequired]
        DataType = ftInteger
      end
      item
        Name = 'title'
        Attributes = [faRequired]
        DataType = ftString
        Size = 70
      end
      item
        Name = 'short_title'
        Attributes = [faRequired]
        DataType = ftString
        Size = 10
      end>
    IndexDefs = <>
    Params = <>
    ProviderName = 'specsProvider'
    StoreDefs = True
    Left = 416
    Top = 208
  end
  object prepodsQuery: TSQLQuery
    Active = True
    MaxBlobSize = -1
    Params = <>
    SQL.Strings = (
      'SELECT id, fio,login,password'
      'FROM prepods')
    SQLConnection = MySQL_Connection
    Left = 56
    Top = 96
  end
  object predmetsQuery: TSQLQuery
    MaxBlobSize = -1
    Params = <>
    SQL.Strings = (
      'SELECT predmets.title, term, specs.short_title, prepods.fio'
      'FROM predmets'
      'LEFT JOIN specs ON id_specs=specs.id'
      'LEFT JOIN prepods ON id_ved_prepod=prepods.id')
    SQLConnection = MySQL_Connection
    Left = 184
    Top = 96
  end
  object groupsQuery: TSQLQuery
    Active = True
    MaxBlobSize = -1
    Params = <>
    SQL.Strings = (
      'SELECT groups.id, group_number, id_specs,course'
      'FROM groups')
    SQLConnection = MySQL_Connection
    Left = 304
    Top = 96
  end
  object specsQuery: TSQLQuery
    MaxBlobSize = -1
    Params = <>
    SQL.Strings = (
      'SELECT id, title, short_title'
      'FROM specs'
      '')
    SQLConnection = MySQL_Connection
    Left = 416
    Top = 96
  end
  object assistentsQuery: TSQLQuery
    Active = True
    MaxBlobSize = -1
    Params = <>
    SQL.Strings = (
      'SELECT *'
      'FROM assistents')
    SQLConnection = MySQL_Connection
    Left = 528
    Top = 96
  end
  object study_typesQuery: TSQLQuery
    Active = True
    MaxBlobSize = -1
    Params = <>
    SQL.Strings = (
      'SELECT title'
      'FROM study_types')
    SQLConnection = MySQL_Connection
    Left = 656
    Top = 96
  end
  object lesson_typesQuery: TSQLQuery
    Active = True
    MaxBlobSize = -1
    Params = <>
    SQL.Strings = (
      'SELECT id, title'
      'FROM lesson_types')
    SQLConnection = MySQL_Connection
    Left = 784
    Top = 96
  end
  object studentsQuery: TSQLQuery
    GetMetadata = True
    Active = True
    MaxBlobSize = -1
    Params = <>
    SQL.Strings = (
      'SELECT id, fio, begin_year, end_year, id_group'
      'FROM students'
      '')
    SQLConnection = MySQL_Connection
    Left = 920
    Top = 96
  end
  object study_planQuery: TSQLQuery
    Active = True
    MaxBlobSize = 1
    Params = <>
    SQL.Strings = (
      'SELECT lesson_types.title, lesson_count, mark_type, formula'
      'FROM study_plan'
      'LEFT JOIN lesson_types ON id_lesson_type=lesson_types.id')
    SQLConnection = MySQL_Connection
    Left = 56
    Top = 344
  end
  object marksQuery: TSQLQuery
    Active = True
    MaxBlobSize = -1
    Params = <>
    SQL.Strings = (
      'SELECT mark, mark_mean, mark_score'
      'FROM marks'
      'LEFT JOIN study_plan ON id_study_plan=study_plan.id')
    SQLConnection = MySQL_Connection
    Left = 184
    Top = 344
  end
  object ratingQuery: TSQLQuery
    Active = True
    MaxBlobSize = -1
    Params = <>
    SQL.Strings = (
      'SELECT *'
      'FROM rating')
    SQLConnection = MySQL_Connection
    Left = 304
    Top = 344
  end
  object study_typesDataSource: TDataSource
    DataSet = study_typesClientDataSet
    Left = 656
    Top = 264
  end
  object study_typesProvider: TDataSetProvider
    DataSet = study_typesQuery
    Left = 656
    Top = 152
  end
  object study_typesClientDataSet: TClientDataSet
    Active = True
    Aggregates = <>
    FieldDefs = <
      item
        Name = 'title'
        Attributes = [faRequired]
        DataType = ftString
        Size = 50
      end>
    IndexDefs = <>
    Params = <>
    ProviderName = 'study_typesProvider'
    StoreDefs = True
    Left = 656
    Top = 208
  end
  object study_planDataSource: TDataSource
    DataSet = study_planClientDataSet
    Left = 56
    Top = 512
  end
  object study_planProvider: TDataSetProvider
    DataSet = study_planQuery
    Left = 56
    Top = 400
  end
  object study_planClientDataSet: TClientDataSet
    Active = True
    Aggregates = <>
    FieldDefs = <
      item
        Name = 'title'
        DataType = ftString
        Size = 50
      end
      item
        Name = 'lesson_count'
        Attributes = [faRequired]
        DataType = ftInteger
      end
      item
        Name = 'mark_type'
        DataType = ftString
        Size = 20
      end
      item
        Name = 'formula'
        DataType = ftMemo
        Size = 1
      end>
    IndexDefs = <>
    Params = <>
    ProviderName = 'study_planProvider'
    StoreDefs = True
    Left = 56
    Top = 456
  end
  object marksDataSource: TDataSource
    DataSet = marksClientDataSet
    Left = 184
    Top = 512
  end
  object marksProvider: TDataSetProvider
    DataSet = marksQuery
    Left = 184
    Top = 400
  end
  object marksClientDataSet: TClientDataSet
    Active = True
    Aggregates = <>
    FieldDefs = <
      item
        Name = 'mark'
        Attributes = [faRequired]
        DataType = ftString
        Size = 20
      end
      item
        Name = 'mark_mean'
        DataType = ftString
        Size = 20
      end
      item
        Name = 'mark_score'
        DataType = ftInteger
      end>
    IndexDefs = <>
    Params = <>
    ProviderName = 'marksProvider'
    StoreDefs = True
    Left = 184
    Top = 456
  end
  object ratingDataSource: TDataSource
    DataSet = ratingClientDataSet
    Left = 304
    Top = 512
  end
  object ratingProvider: TDataSetProvider
    DataSet = ratingQuery
    Left = 304
    Top = 400
  end
  object ratingClientDataSet: TClientDataSet
    Active = True
    Aggregates = <>
    FieldDefs = <
      item
        Name = 'id'
        Attributes = [faRequired]
        DataType = ftInteger
      end
      item
        Name = 'id_student'
        Attributes = [faRequired]
        DataType = ftInteger
      end
      item
        Name = 'id_step'
        Attributes = [faRequired]
        DataType = ftInteger
      end
      item
        Name = 'id_mark'
        Attributes = [faRequired]
        DataType = ftInteger
      end
      item
        Name = 'id_prepod'
        Attributes = [faRequired]
        DataType = ftInteger
      end
      item
        Name = 'datestamp'
        DataType = ftTimeStamp
      end>
    IndexDefs = <>
    Params = <>
    ProviderName = 'ratingProvider'
    StoreDefs = True
    Left = 304
    Top = 456
  end
  object queryProvider: TDataSetProvider
    DataSet = SQLQuery
    Left = 536
    Top = 400
  end
  object queryClientDataSet: TClientDataSet
    Active = True
    Aggregates = <>
    FieldDefs = <
      item
        Name = 'id'
        Attributes = [faRequired]
        DataType = ftInteger
      end
      item
        Name = 'fio'
        Attributes = [faRequired]
        DataType = ftString
        Size = 50
      end
      item
        Name = 'login'
        DataType = ftString
        Size = 20
      end
      item
        Name = 'password'
        DataType = ftString
        Size = 20
      end>
    IndexDefs = <>
    Params = <>
    ProviderName = 'queryProvider'
    StoreDefs = True
    Left = 536
    Top = 456
  end
  object queryDataSource: TDataSource
    DataSet = queryClientDataSet
    Left = 536
    Top = 512
  end
  object stepQuery: TSQLQuery
    NumericMapping = True
    Active = True
    MaxBlobSize = -1
    Params = <>
    SQL.Strings = (
      
        'SELECT lesson_number, step_name, step_date, sub_step_count, step' +
        '_dates.id'
      'FROM step_dates'
      'LEFT JOIN study_plan ON id_study_plan=study_plan.id'
      '')
    SQLConnection = MySQL_Connection
    Left = 400
    Top = 344
  end
  object stepSetProvider: TDataSetProvider
    DataSet = stepQuery
    Left = 400
    Top = 400
  end
  object stepClientDataSet: TClientDataSet
    Active = True
    Aggregates = <>
    FieldDefs = <
      item
        Name = 'lesson_number'
        Attributes = [faRequired]
        DataType = ftInteger
      end
      item
        Name = 'step_name'
        DataType = ftString
        Size = 40
      end
      item
        Name = 'step_date'
        DataType = ftDate
      end
      item
        Name = 'sub_step_count'
        DataType = ftInteger
      end
      item
        Name = 'id'
        Attributes = [faRequired]
        DataType = ftInteger
      end>
    IndexDefs = <>
    Params = <>
    ProviderName = 'stepSetProvider'
    StoreDefs = True
    Left = 400
    Top = 456
  end
  object stepDataSource: TDataSource
    DataSet = stepClientDataSet
    Left = 400
    Top = 512
  end
  object sstepQuery: TSQLQuery
    NumericMapping = True
    Active = True
    MaxBlobSize = -1
    Params = <>
    SQL.Strings = (
      'SELECT sub_step_name, sub_step_date '
      'FROM substep_dates'
      'LEFT JOIN step_dates ON id_step=step_dates.id')
    SQLConnection = MySQL_Connection
    Left = 656
    Top = 344
  end
  object sstepSetProvider: TDataSetProvider
    DataSet = sstepQuery
    Left = 656
    Top = 400
  end
  object sstepClientDataSet: TClientDataSet
    Active = True
    Aggregates = <>
    FieldDefs = <
      item
        Name = 'sub_step_name'
        DataType = ftString
        Size = 40
      end
      item
        Name = 'sub_step_date'
        DataType = ftDate
      end>
    IndexDefs = <>
    Params = <>
    ProviderName = 'sstepSetProvider'
    StoreDefs = True
    Left = 656
    Top = 456
  end
  object sstepDataSource: TDataSource
    DataSet = sstepClientDataSet
    Left = 656
    Top = 512
  end
end
